﻿<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SearchTour.ascx.cs"
    Inherits="Indochinaodyssey.UserControl.Other.SearchTour" %>
<asp:Label ID="lblAllCountries" runat="server" CssClass="lable" Text="All Countries:"></asp:Label>
<asp:DropDownList ID="ddlAllCountries" runat="server" CssClass="drop-down-list" DataSourceID="ObjectDataSource1"
    DataTextField="TenQuocGia" DataValueField="Id" AutoPostBack="True">
</asp:DropDownList>
<asp:Label ID="lblTypeOfTuor" runat="server" CssClass="lable" Text="Type of Tours:"></asp:Label>
<asp:DropDownList ID="ddlTyoeOfTour" runat="server" CssClass="drop-down-list" DataSourceID="SqlDataSource1"
    DataTextField="TenDanhMuc" DataValueField="ID" AutoPostBack="True">
</asp:DropDownList>
<asp:Label ID="lblInformation" runat="server" CssClass="lable" Text="Tour:"></asp:Label>
<asp:DropDownList ID="ddlInfo" runat="server" CssClass="drop-down-list" DataSourceID="SqlDataSource2"
    DataTextField="TenTheLoai" DataValueField="ID">
</asp:DropDownList>
<br />
<asp:Button ID="btnSearch" runat="server" Text="Search Tour" CssClass="btn-search"
    OnClick="btnSearch_Click" />
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetAll"
    TypeName="IOBusiness.clsBSQuocGia"></asp:ObjectDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
    SelectCommand="SELECT dbo.tblDanhMuc.ID, dbo.tblDanhMuc.TenDanhMuc FROM dbo.tblTheLoai INNER JOIN dbo.tblDanhMuc ON dbo.tblTheLoai.MaDanhMuc = dbo.tblDanhMuc.ID WHERE (dbo.tblTheLoai.MaQuocGia = @maquocgia) AND (dbo.tblDanhMuc.TypeID &lt;&gt; 1)">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlAllCountries" Name="maquocgia" PropertyName="SelectedValue" />
    </SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
    SelectCommand="SELECT TenTheLoai, ID FROM dbo.tblTheLoai WHERE (MaDanhMuc = @madanhmuc) AND (MaQuocGia = @maquocgia)">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlTyoeOfTour" Name="madanhmuc" PropertyName="SelectedValue" />
        <asp:ControlParameter ControlID="ddlAllCountries" Name="maquocgia" PropertyName="SelectedValue" />
    </SelectParameters>
</asp:SqlDataSource>
